DROP TABLE IF EXISTS `USER_USER_LEVEL`; CREATE TABLE `USER_USER_LEVEL` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `USER_USER_LEVEL` (`EN`) VALUES ('');
INSERT INTO `USER_USER_LEVEL` (`EN`) VALUES ('Ground level');
INSERT INTO `USER_USER_LEVEL` (`EN`) VALUES ('National focus point');
INSERT INTO `USER_USER_LEVEL` (`EN`) VALUES ('EU monitoring centre');
DROP TABLE IF EXISTS `A_NEWENTRY_NEWENTRY_SOURCETYPE`; CREATE TABLE `A_NEWENTRY_NEWENTRY_SOURCETYPE` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('Law enforcement authorities');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('Police');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('Customs');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('Other');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('Public prosecutors');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('Courts');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('Judicial authorities');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('NGOs');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('GOs');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('Studies');
INSERT INTO `A_NewEntry_NEWENTRY_SOURCETYPE` (`EN`) VALUES ('Surveys');
DROP TABLE IF EXISTS `A_NEWENTRY_NEWENTRY_LEVEL`; CREATE TABLE `A_NEWENTRY_NEWENTRY_LEVEL` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `A_NewEntry_NEWENTRY_LEVEL` (`EN`) VALUES ('');
INSERT INTO `A_NewEntry_NEWENTRY_LEVEL` (`EN`) VALUES ('Central');
INSERT INTO `A_NewEntry_NEWENTRY_LEVEL` (`EN`) VALUES ('Regional');
INSERT INTO `A_NewEntry_NEWENTRY_LEVEL` (`EN`) VALUES ('Local');
DROP TABLE IF EXISTS `B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION`; CREATE TABLE `B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION` (`EN`) VALUES ('');
INSERT INTO `B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION` (`EN`) VALUES ('< 1 month');
INSERT INTO `B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION` (`EN`) VALUES ('1-3 months');
INSERT INTO `B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION` (`EN`) VALUES ('6-12 months');
INSERT INTO `B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION` (`EN`) VALUES ('> 12 months');
INSERT INTO `B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION`; CREATE TABLE `B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION` (`EN`) VALUES ('');
INSERT INTO `B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION` (`EN`) VALUES ('Sexual');
INSERT INTO `B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION` (`EN`) VALUES ('Labour');
INSERT INTO `B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION` (`EN`) VALUES ('Other');
DROP TABLE IF EXISTS `B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION`; CREATE TABLE `B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION` (`EN`) VALUES ('');
INSERT INTO `B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION` (`EN`) VALUES ('< 3 months');
INSERT INTO `B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION` (`EN`) VALUES ('3-6 months');
INSERT INTO `B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION` (`EN`) VALUES ('6-12 months');
INSERT INTO `B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION` (`EN`) VALUES ('> 12 months');
INSERT INTO `B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_PERSONALDATA_SEXOFTHEVICTIM`; CREATE TABLE `B_2_VICTIM_PERSONALDATA_SEXOFTHEVICTIM` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_PERSONALDATA_SEXOFTHEVICTIM` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_PERSONALDATA_SEXOFTHEVICTIM` (`EN`) VALUES ('male');
INSERT INTO `B_2_Victim_PERSONALDATA_SEXOFTHEVICTIM` (`EN`) VALUES ('female');
INSERT INTO `B_2_Victim_PERSONALDATA_SEXOFTHEVICTIM` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_PERSONALDATA_MARITALSTATUS`; CREATE TABLE `B_2_VICTIM_PERSONALDATA_MARITALSTATUS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('married');
INSERT INTO `B_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('unmarried');
INSERT INTO `B_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('divorced');
INSERT INTO `B_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('actually divorced');
INSERT INTO `B_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('widower');
INSERT INTO `B_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('living together');
INSERT INTO `B_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI`; CREATE TABLE `B_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('single-parent family');
INSERT INTO `B_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('two parent family');
INSERT INTO `B_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('divorced parents');
INSERT INTO `B_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('orphan');
INSERT INTO `B_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`; CREATE TABLE `B_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('< 6 years');
INSERT INTO `B_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('between 6-12');
INSERT INTO `B_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('> 12 years');
INSERT INTO `B_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI`; CREATE TABLE `B_2_VICTIM_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI` (`EN`) VALUES ('Residence permit');
INSERT INTO `B_2_Victim_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI` (`EN`) VALUES ('Asylum seeker');
INSERT INTO `B_2_Victim_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI` (`EN`) VALUES ('Refugee');
INSERT INTO `B_2_Victim_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI` (`EN`) VALUES ('Irregular migrant');
INSERT INTO `B_2_Victim_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI` (`EN`) VALUES ('Tourist');
DROP TABLE IF EXISTS `B_2_VICTIM_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW`; CREATE TABLE `B_2_VICTIM_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN`) VALUES ('alone');
INSERT INTO `B_2_Victim_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN`) VALUES ('spouse');
INSERT INTO `B_2_Victim_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN`) VALUES ('partner');
INSERT INTO `B_2_Victim_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN`) VALUES ('family');
INSERT INTO `B_2_Victim_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN`) VALUES ('friends');
INSERT INTO `B_2_Victim_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN`) VALUES ('relatives');
INSERT INTO `B_2_Victim_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN`) VALUES ('institution');
INSERT INTO `B_2_Victim_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN`) VALUES ('other');
DROP TABLE IF EXISTS `B_2_VICTIM_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT`; CREATE TABLE `B_2_VICTIM_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT` (`EN`) VALUES ('Village');
INSERT INTO `B_2_Victim_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT` (`EN`) VALUES ('City');
INSERT INTO `B_2_Victim_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT` (`EN`) VALUES ('Capital city');
INSERT INTO `B_2_Victim_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_INCOME_OCCUPATIONOFTHEVICTIMBEFO`; CREATE TABLE `B_2_VICTIM_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) VALUES ('Attending school');
INSERT INTO `B_2_Victim_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) VALUES ('Not attending school');
INSERT INTO `B_2_Victim_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) VALUES ('Agriculture');
INSERT INTO `B_2_Victim_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) VALUES ('Industry');
INSERT INTO `B_2_Victim_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) VALUES ('Commerce');
INSERT INTO `B_2_Victim_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) VALUES ('Services');
INSERT INTO `B_2_Victim_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) VALUES ('Private');
INSERT INTO `B_2_Victim_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) VALUES ('Leisure');
INSERT INTO `B_2_Victim_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) VALUES ('other');
DROP TABLE IF EXISTS `B_2_VICTIM_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI`; CREATE TABLE `B_2_VICTIM_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI` (`EN`) VALUES ('well-off');
INSERT INTO `B_2_Victim_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI` (`EN`) VALUES ('standard');
INSERT INTO `B_2_Victim_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI` (`EN`) VALUES ('poor');
INSERT INTO `B_2_Victim_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI` (`EN`) VALUES ('very poor');
INSERT INTO `B_2_Victim_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON`; CREATE TABLE `B_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('family');
INSERT INTO `B_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('relative');
INSERT INTO `B_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('partner');
INSERT INTO `B_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('friend');
INSERT INTO `B_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('acquaintance');
INSERT INTO `B_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('stranger');
INSERT INTO `B_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('business contact');
INSERT INTO `B_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('facilitator');
INSERT INTO `B_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION`; CREATE TABLE `B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION` (`EN`) VALUES ('dancer');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION` (`EN`) VALUES ('animation girl');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION` (`EN`) VALUES ('escort/call girl');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION` (`EN`) VALUES ('masseur/masseuse');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION` (`EN`) VALUES ('prostitute');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION` (`EN`) VALUES ('stripper');
DROP TABLE IF EXISTS `B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION`; CREATE TABLE `B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('au pair');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('bartender/maid');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('waiter/waitress');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in agriculture sector');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in construction sector');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in textile sector');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in filling station');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in garage');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in restaurant/catering');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in transport sector');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in fishing fleet');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in mining sector');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in embassy/diplomatic sector');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('employee in amusement sector');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('domestic servant');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('door waiter');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('telephone receptionist');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) VALUES ('model');
DROP TABLE IF EXISTS `B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION`; CREATE TABLE `B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` (`EN`) VALUES ('military service');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` (`EN`) VALUES ('beggar');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` (`EN`) VALUES ('petty criminal');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` (`EN`) VALUES ('street sellor');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` (`EN`) VALUES ('donor of organs');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` (`EN`) VALUES ('other');
INSERT INTO `B_2_Victim_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM`; CREATE TABLE `B_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('< EUR 1_000');
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('EUR 1_000 - EUR 2_000');
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('EUR 2_000 - EUR 5_000');
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('> EUR 5_000');
DROP TABLE IF EXISTS `B_2_VICTIM_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS`; CREATE TABLE `B_2_VICTIM_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS` (`EN`) VALUES ('EUR 0 (= no debt to be repaid)');
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS` (`EN`) VALUES ('< EUR 5_000');
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS` (`EN`) VALUES ('EUR 5_000 - EUR 10_000');
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS` (`EN`) VALUES ('EUR 10_000 - EUR 20_000');
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS` (`EN`) VALUES ('> EUR 20_000');
INSERT INTO `B_2_Victim_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION`; CREATE TABLE `B_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) VALUES ('sexual');
INSERT INTO `B_2_Victim_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) VALUES ('labour');
INSERT INTO `B_2_Victim_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) VALUES ('other forms of exploitation');
DROP TABLE IF EXISTS `B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX`; CREATE TABLE `B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX` (`EN`) VALUES ('< EUR 100');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX` (`EN`) VALUES ('EUR 100 - EUR 500');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX` (`EN`) VALUES ('EUR 500 - EUR 1_000');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX` (`EN`) VALUES ('> EUR 1_000');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR`; CREATE TABLE `B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR` (`EN`) VALUES ('< EUR 70');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR` (`EN`) VALUES ('EUR 70 - EUR 125');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR` (`EN`) VALUES ('EUR 125 - EUR 175');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR` (`EN`) VALUES ('> EUR 175');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML`; CREATE TABLE `B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML` (`EN`) VALUES ('< EUR 300');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML` (`EN`) VALUES ('EUR 300 - EUR 500');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML` (`EN`) VALUES ('EUR 500 - EUR 700');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML` (`EN`) VALUES ('> EUR 700');
INSERT INTO `B_2_Victim_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_2_VICTIM_INSTITUTIONPROVIDINGASSIS_INSTITUTION`; CREATE TABLE `B_2_VICTIM_INSTITUTIONPROVIDINGASSIS_INSTITUTION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_INSTITUTIONPROVIDINGASSIS_INSTITUTION` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_INSTITUTIONPROVIDINGASSIS_INSTITUTION` (`EN`) VALUES ('IOM');
INSERT INTO `B_2_Victim_INSTITUTIONPROVIDINGASSIS_INSTITUTION` (`EN`) VALUES ('NGO');
INSERT INTO `B_2_Victim_INSTITUTIONPROVIDINGASSIS_INSTITUTION` (`EN`) VALUES ('GO');
INSERT INTO `B_2_Victim_INSTITUTIONPROVIDINGASSIS_INSTITUTION` (`EN`) VALUES ('police');
INSERT INTO `B_2_Victim_INSTITUTIONPROVIDINGASSIS_INSTITUTION` (`EN`) VALUES ('medical system');
INSERT INTO `B_2_Victim_INSTITUTIONPROVIDINGASSIS_INSTITUTION` (`EN`) VALUES ('social services');
INSERT INTO `B_2_Victim_INSTITUTIONPROVIDINGASSIS_INSTITUTION` (`EN`) VALUES ('other (all fields but these already specifically marked)');
DROP TABLE IF EXISTS `B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO`; CREATE TABLE `B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` (`EN`) VALUES ('family');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` (`EN`) VALUES ('friends');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` (`EN`) VALUES ('partner');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` (`EN`) VALUES ('NGO');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` (`EN`) VALUES ('GO');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` (`EN`) VALUES ('alone');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` (`EN`) VALUES ('no place');
DROP TABLE IF EXISTS `B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING`; CREATE TABLE `B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING` (`EN`) VALUES ('family');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING` (`EN`) VALUES ('job');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING` (`EN`) VALUES ('ngo');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING` (`EN`) VALUES ('go');
INSERT INTO `B_2_Victim_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING` (`EN`) VALUES ('no support');
DROP TABLE IF EXISTS `B_2_VICTIM_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH`; CREATE TABLE `B_2_VICTIM_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_2_Victim_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH` (`EN`) VALUES ('');
INSERT INTO `B_2_Victim_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH` (`EN`) VALUES ('return to school');
INSERT INTO `B_2_Victim_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH` (`EN`) VALUES ('return to previous job');
INSERT INTO `B_2_Victim_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH` (`EN`) VALUES ('find another job');
INSERT INTO `B_2_Victim_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH` (`EN`) VALUES ('find a legal job abroad');
INSERT INTO `B_2_Victim_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH` (`EN`) VALUES ('travel abroad');
INSERT INTO `B_2_Victim_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR`; CREATE TABLE `B_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_3_Author_PERSONALDATA_PERSONALITYOFTHEAUTHOR` (`EN`) VALUES ('');
INSERT INTO `B_3_Author_PERSONALDATA_PERSONALITYOFTHEAUTHOR` (`EN`) VALUES ('physical person');
INSERT INTO `B_3_Author_PERSONALDATA_PERSONALITYOFTHEAUTHOR` (`EN`) VALUES ('legal person');
DROP TABLE IF EXISTS `B_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR`; CREATE TABLE `B_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('');
INSERT INTO `B_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('male');
INSERT INTO `B_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('female');
INSERT INTO `B_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE`; CREATE TABLE `B_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('');
INSERT INTO `B_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('Village');
INSERT INTO `B_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('City');
INSERT INTO `B_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('Capital city');
INSERT INTO `B_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_3_AUTHOR_PERSONALDATA_MARITALSTATUS`; CREATE TABLE `B_3_AUTHOR_PERSONALDATA_MARITALSTATUS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('');
INSERT INTO `B_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('married');
INSERT INTO `B_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('unmarried');
INSERT INTO `B_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('divorced');
INSERT INTO `B_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('actually divorced');
INSERT INTO `B_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('widower');
INSERT INTO `B_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('living together');
INSERT INTO `B_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`; CREATE TABLE `B_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('');
INSERT INTO `B_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('< 6 years');
INSERT INTO `B_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('between 6-12 years');
INSERT INTO `B_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('> 12 years');
INSERT INTO `B_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR`; CREATE TABLE `B_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('');
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Self employed');
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Unemployed');
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Family work');
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Private employee');
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Public employee');
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Industry worker');
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Agriculture');
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Domestic worker');
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Sex industry');
INSERT INTO `B_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `B_3_AUTHOR_INCOME_STATUSOFTHEAUTHORTOWARDSI`; CREATE TABLE `B_3_AUTHOR_INCOME_STATUSOFTHEAUTHORTOWARDSI` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_3_Author_INCOME_STATUSOFTHEAUTHORTOWARDSI` (`EN`) VALUES ('');
INSERT INTO `B_3_Author_INCOME_STATUSOFTHEAUTHORTOWARDSI` (`EN`) VALUES ('Illegal migrant');
INSERT INTO `B_3_Author_INCOME_STATUSOFTHEAUTHORTOWARDSI` (`EN`) VALUES ('Residence permit');
INSERT INTO `B_3_Author_INCOME_STATUSOFTHEAUTHORTOWARDSI` (`EN`) VALUES ('refugee');
DROP TABLE IF EXISTS `B_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE`; CREATE TABLE `B_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_3_Author_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN`) VALUES ('');
INSERT INTO `B_3_Author_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN`) VALUES ('3-5');
INSERT INTO `B_3_Author_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN`) VALUES ('6-10');
INSERT INTO `B_3_Author_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN`) VALUES ('>10');
DROP TABLE IF EXISTS `B_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN`; CREATE TABLE `B_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `B_3_Author_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN`) VALUES ('');
INSERT INTO `B_3_Author_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN`) VALUES ('head');
INSERT INTO `B_3_Author_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN`) VALUES ('active member');
INSERT INTO `B_3_Author_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN`) VALUES ('external co-operator');
DROP TABLE IF EXISTS `C_1_EVENT_ECPDURATIONOFTHEEVENT_DURATION`; CREATE TABLE `C_1_EVENT_ECPDURATIONOFTHEEVENT_DURATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_1_Event_ECPDURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('');
INSERT INTO `C_1_Event_ECPDURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('< 1 month');
INSERT INTO `C_1_Event_ECPDURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('1-6 months');
INSERT INTO `C_1_Event_ECPDURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('> 6 months');
INSERT INTO `C_1_Event_ECPDURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_1_EVENT_ESADURATIONOFTHEEVENT_DURATION`; CREATE TABLE `C_1_EVENT_ESADURATIONOFTHEEVENT_DURATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_1_Event_ESADURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('');
INSERT INTO `C_1_Event_ESADURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('< 1 month');
INSERT INTO `C_1_Event_ESADURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('1-6 months');
INSERT INTO `C_1_Event_ESADURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('> 6 months');
INSERT INTO `C_1_Event_ESADURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_1_EVENT_ESTDURATIONOFTHEEVENT_DURATION`; CREATE TABLE `C_1_EVENT_ESTDURATIONOFTHEEVENT_DURATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_1_Event_ESTDURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('');
INSERT INTO `C_1_Event_ESTDURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('< 1 month');
INSERT INTO `C_1_Event_ESTDURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('1-6 months');
INSERT INTO `C_1_Event_ESTDURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('> 6 months');
INSERT INTO `C_1_Event_ESTDURATIONOFTHEEVENT_DURATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_1_EVENT_ECPRODATEOFDURATION_DURATION`; CREATE TABLE `C_1_EVENT_ECPRODATEOFDURATION_DURATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_1_Event_ECPRODATEOFDURATION_DURATION` (`EN`) VALUES ('');
INSERT INTO `C_1_Event_ECPRODATEOFDURATION_DURATION` (`EN`) VALUES ('< 1 month');
INSERT INTO `C_1_Event_ECPRODATEOFDURATION_DURATION` (`EN`) VALUES ('1-6 months');
INSERT INTO `C_1_Event_ECPRODATEOFDURATION_DURATION` (`EN`) VALUES ('> 6 months');
INSERT INTO `C_1_Event_ECPRODATEOFDURATION_DURATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM`; CREATE TABLE `C_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_PERSONALDATA_GENDEROFTHEVICTIM` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_PERSONALDATA_GENDEROFTHEVICTIM` (`EN`) VALUES ('Male');
INSERT INTO `C_2_Victim_PERSONALDATA_GENDEROFTHEVICTIM` (`EN`) VALUES ('Female');
INSERT INTO `C_2_Victim_PERSONALDATA_GENDEROFTHEVICTIM` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_2_VICTIM_PERSONALDATA_MARITALSTATUS`; CREATE TABLE `C_2_VICTIM_PERSONALDATA_MARITALSTATUS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Married');
INSERT INTO `C_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Unmarried');
INSERT INTO `C_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Divorced');
INSERT INTO `C_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Actually divorced');
INSERT INTO `C_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Widower');
INSERT INTO `C_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Living together');
INSERT INTO `C_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI`; CREATE TABLE `C_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('single-parent family');
INSERT INTO `C_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('two parent family');
INSERT INTO `C_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('divorced parents');
INSERT INTO `C_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('orphan');
INSERT INTO `C_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`; CREATE TABLE `C_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('< 6 years');
INSERT INTO `C_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('Between 6-12 years');
INSERT INTO `C_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('> 12 years');
INSERT INTO `C_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI`; CREATE TABLE `C_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('alone');
INSERT INTO `C_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('with partner');
INSERT INTO `C_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('with parents/family');
INSERT INTO `C_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('with friends/acquaintances');
INSERT INTO `C_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('institution');
INSERT INTO `C_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('other');
DROP TABLE IF EXISTS `C_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCE`; CREATE TABLE `C_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCE` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('Village');
INSERT INTO `C_2_Victim_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('City');
INSERT INTO `C_2_Victim_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('Capital city');
INSERT INTO `C_2_Victim_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('Unknown');
DROP TABLE IF EXISTS `C_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM`; CREATE TABLE `C_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('attending school');
INSERT INTO `C_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('not attending school');
INSERT INTO `C_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('agriculture');
INSERT INTO `C_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('industry');
INSERT INTO `C_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('commerce');
INSERT INTO `C_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('services');
INSERT INTO `C_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('private');
INSERT INTO `C_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('leisure');
INSERT INTO `C_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('other');
DROP TABLE IF EXISTS `C_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON`; CREATE TABLE `C_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('family');
INSERT INTO `C_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('relative');
INSERT INTO `C_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('partner');
INSERT INTO `C_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('friend');
INSERT INTO `C_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('acquaintance');
INSERT INTO `C_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('stranger');
INSERT INTO `C_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('business contact');
INSERT INTO `C_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('pimp');
INSERT INTO `C_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM`; CREATE TABLE `C_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('< EUR 1_000');
INSERT INTO `C_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('EUR 1_000 - EUR 2_000');
INSERT INTO `C_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('EUR 2_000 - EUR 5_000');
INSERT INTO `C_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('> EUR 5_000');
INSERT INTO `C_2_Victim_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION`; CREATE TABLE `C_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) VALUES ('sexual');
INSERT INTO `C_2_Victim_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) VALUES ('labour');
INSERT INTO `C_2_Victim_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) VALUES ('criminality');
INSERT INTO `C_2_Victim_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) VALUES ('begging');
INSERT INTO `C_2_Victim_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) VALUES ('organ smuggling');
DROP TABLE IF EXISTS `C_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION`; CREATE TABLE `C_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('');
INSERT INTO `C_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('NGO');
INSERT INTO `C_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('GO');
INSERT INTO `C_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('Police');
INSERT INTO `C_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('Medical system');
INSERT INTO `C_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('Social services');
INSERT INTO `C_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('other');
DROP TABLE IF EXISTS `C_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR`; CREATE TABLE `C_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_3_Author_PERSONALDATA_PERSONALITYOFTHEAUTHOR` (`EN`) VALUES ('');
INSERT INTO `C_3_Author_PERSONALDATA_PERSONALITYOFTHEAUTHOR` (`EN`) VALUES ('physical person');
INSERT INTO `C_3_Author_PERSONALDATA_PERSONALITYOFTHEAUTHOR` (`EN`) VALUES ('legal person');
DROP TABLE IF EXISTS `C_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR`; CREATE TABLE `C_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('');
INSERT INTO `C_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('male');
INSERT INTO `C_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('female');
INSERT INTO `C_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE`; CREATE TABLE `C_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('');
INSERT INTO `C_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('Village');
INSERT INTO `C_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('City');
INSERT INTO `C_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('Capital city');
INSERT INTO `C_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_3_AUTHOR_PERSONALDATA_MARITALSTATUS`; CREATE TABLE `C_3_AUTHOR_PERSONALDATA_MARITALSTATUS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('');
INSERT INTO `C_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('married');
INSERT INTO `C_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('unmarried');
INSERT INTO `C_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('divorced');
INSERT INTO `C_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('actually divorced');
INSERT INTO `C_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('widower');
INSERT INTO `C_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('living together');
INSERT INTO `C_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`; CREATE TABLE `C_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('');
INSERT INTO `C_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('< 6 years');
INSERT INTO `C_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('between 6 and 12 years');
INSERT INTO `C_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('> 12 years');
INSERT INTO `C_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR`; CREATE TABLE `C_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Self employed');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Unemployed');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Family work');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Private employee');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Public employee');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('agriculture');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('industry');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('commerce');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('services');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('private');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('leisure');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('other');
INSERT INTO `C_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `C_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE`; CREATE TABLE `C_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_3_Author_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN`) VALUES ('');
INSERT INTO `C_3_Author_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN`) VALUES ('3-5');
INSERT INTO `C_3_Author_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN`) VALUES ('6-10');
INSERT INTO `C_3_Author_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN`) VALUES ('>10');
DROP TABLE IF EXISTS `C_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN`; CREATE TABLE `C_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `C_3_Author_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN`) VALUES ('');
INSERT INTO `C_3_Author_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN`) VALUES ('head');
INSERT INTO `C_3_Author_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN`) VALUES ('active member');
INSERT INTO `C_3_Author_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN`) VALUES ('external co-operator');
DROP TABLE IF EXISTS `D_1_EVENT_RUNAWAYSDURATIONOFTHEEVEN_DURATION`; CREATE TABLE `D_1_EVENT_RUNAWAYSDURATIONOFTHEEVEN_DURATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_1_Event_RUNAWAYSDURATIONOFTHEEVEN_DURATION` (`EN`) VALUES ('');
INSERT INTO `D_1_Event_RUNAWAYSDURATIONOFTHEEVEN_DURATION` (`EN`) VALUES ('< 1 month');
INSERT INTO `D_1_Event_RUNAWAYSDURATIONOFTHEEVEN_DURATION` (`EN`) VALUES ('1-6 months');
INSERT INTO `D_1_Event_RUNAWAYSDURATIONOFTHEEVEN_DURATION` (`EN`) VALUES ('> 6 months');
INSERT INTO `D_1_Event_RUNAWAYSDURATIONOFTHEEVEN_DURATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_1_EVENT_ABDUCTI3RDPERSONDURATIONO_DURATION`; CREATE TABLE `D_1_EVENT_ABDUCTI3RDPERSONDURATIONO_DURATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_1_Event_ABDUCTI3RDPERSONDURATIONO_DURATION` (`EN`) VALUES ('');
INSERT INTO `D_1_Event_ABDUCTI3RDPERSONDURATIONO_DURATION` (`EN`) VALUES ('< 1 month');
INSERT INTO `D_1_Event_ABDUCTI3RDPERSONDURATIONO_DURATION` (`EN`) VALUES ('1-6 months');
INSERT INTO `D_1_Event_ABDUCTI3RDPERSONDURATIONO_DURATION` (`EN`) VALUES ('> 6 months');
INSERT INTO `D_1_Event_ABDUCTI3RDPERSONDURATIONO_DURATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_1_EVENT_PARENTALABDUCTDURATIONOFT_DURATION`; CREATE TABLE `D_1_EVENT_PARENTALABDUCTDURATIONOFT_DURATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_1_Event_PARENTALABDUCTDURATIONOFT_DURATION` (`EN`) VALUES ('');
INSERT INTO `D_1_Event_PARENTALABDUCTDURATIONOFT_DURATION` (`EN`) VALUES ('< 1 month');
INSERT INTO `D_1_Event_PARENTALABDUCTDURATIONOFT_DURATION` (`EN`) VALUES ('1-6 months');
INSERT INTO `D_1_Event_PARENTALABDUCTDURATIONOFT_DURATION` (`EN`) VALUES ('> 6 months');
INSERT INTO `D_1_Event_PARENTALABDUCTDURATIONOFT_DURATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_1_EVENT_LOSTINFUREDMISSDURATIONOF_DURATION`; CREATE TABLE `D_1_EVENT_LOSTINFUREDMISSDURATIONOF_DURATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_1_Event_LOSTINFUREDMISSDURATIONOF_DURATION` (`EN`) VALUES ('');
INSERT INTO `D_1_Event_LOSTINFUREDMISSDURATIONOF_DURATION` (`EN`) VALUES ('< 1 month');
INSERT INTO `D_1_Event_LOSTINFUREDMISSDURATIONOF_DURATION` (`EN`) VALUES ('1-6 months');
INSERT INTO `D_1_Event_LOSTINFUREDMISSDURATIONOF_DURATION` (`EN`) VALUES ('> 6 months');
INSERT INTO `D_1_Event_LOSTINFUREDMISSDURATIONOF_DURATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_1_EVENT_MISSUNACMIGDURATIONOFTHEE_DURATION`; CREATE TABLE `D_1_EVENT_MISSUNACMIGDURATIONOFTHEE_DURATION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_1_Event_MISSUNACMIGDURATIONOFTHEE_DURATION` (`EN`) VALUES ('');
INSERT INTO `D_1_Event_MISSUNACMIGDURATIONOFTHEE_DURATION` (`EN`) VALUES ('< 1 month');
INSERT INTO `D_1_Event_MISSUNACMIGDURATIONOFTHEE_DURATION` (`EN`) VALUES ('1-6 months');
INSERT INTO `D_1_Event_MISSUNACMIGDURATIONOFTHEE_DURATION` (`EN`) VALUES ('> 6 months');
INSERT INTO `D_1_Event_MISSUNACMIGDURATIONOFTHEE_DURATION` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM`; CREATE TABLE `D_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_2_Victim_PERSONALDATA_GENDEROFTHEVICTIM` (`EN`) VALUES ('');
INSERT INTO `D_2_Victim_PERSONALDATA_GENDEROFTHEVICTIM` (`EN`) VALUES ('male');
INSERT INTO `D_2_Victim_PERSONALDATA_GENDEROFTHEVICTIM` (`EN`) VALUES ('female');
INSERT INTO `D_2_Victim_PERSONALDATA_GENDEROFTHEVICTIM` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_2_VICTIM_PERSONALDATA_MARITALSTATUS`; CREATE TABLE `D_2_VICTIM_PERSONALDATA_MARITALSTATUS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('');
INSERT INTO `D_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Married');
INSERT INTO `D_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Unmarried');
INSERT INTO `D_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Divorced');
INSERT INTO `D_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Actually divorced');
INSERT INTO `D_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Widower');
INSERT INTO `D_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('Living together');
INSERT INTO `D_2_Victim_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI`; CREATE TABLE `D_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('');
INSERT INTO `D_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('single-parent family');
INSERT INTO `D_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('two parent family');
INSERT INTO `D_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('divorced parents');
INSERT INTO `D_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('orphan');
INSERT INTO `D_2_Victim_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`; CREATE TABLE `D_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('');
INSERT INTO `D_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('< 6 years');
INSERT INTO `D_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('Between 6-12 years');
INSERT INTO `D_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('> 12 years');
INSERT INTO `D_2_Victim_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI`; CREATE TABLE `D_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('');
INSERT INTO `D_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('alone');
INSERT INTO `D_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('with partner');
INSERT INTO `D_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('with parents/family');
INSERT INTO `D_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('with friends/acquaintances');
INSERT INTO `D_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('institution');
INSERT INTO `D_2_Victim_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) VALUES ('other');
DROP TABLE IF EXISTS `D_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT`; CREATE TABLE `D_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_2_Victim_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT` (`EN`) VALUES ('');
INSERT INTO `D_2_Victim_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT` (`EN`) VALUES ('village');
INSERT INTO `D_2_Victim_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT` (`EN`) VALUES ('city');
INSERT INTO `D_2_Victim_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT` (`EN`) VALUES ('capital city');
INSERT INTO `D_2_Victim_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM`; CREATE TABLE `D_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('Attending school');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('Not attending school');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('Family work');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('Private employee');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('Public employee');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('agriculture');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('industry');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('commerce');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('services');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('private');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('leisure');
INSERT INTO `D_2_Victim_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) VALUES ('other unknown');
DROP TABLE IF EXISTS `D_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON`; CREATE TABLE `D_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('');
INSERT INTO `D_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('family');
INSERT INTO `D_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('relative');
INSERT INTO `D_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('partner');
INSERT INTO `D_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('friend');
INSERT INTO `D_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('acquaintance');
INSERT INTO `D_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('stranger');
INSERT INTO `D_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('business contact');
INSERT INTO `D_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('pimp');
INSERT INTO `D_2_Victim_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION`; CREATE TABLE `D_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('');
INSERT INTO `D_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('NGO');
INSERT INTO `D_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('GO');
INSERT INTO `D_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('Police');
INSERT INTO `D_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('Medical system');
INSERT INTO `D_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('Social services');
INSERT INTO `D_2_Victim_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) VALUES ('other');
DROP TABLE IF EXISTS `D_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR`; CREATE TABLE `D_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('');
INSERT INTO `D_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('male');
INSERT INTO `D_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('female');
INSERT INTO `D_3_Author_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE`; CREATE TABLE `D_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('');
INSERT INTO `D_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('Village');
INSERT INTO `D_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('City');
INSERT INTO `D_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('Capital city');
INSERT INTO `D_3_Author_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_3_AUTHOR_PERSONALDATA_MARITALSTATUS`; CREATE TABLE `D_3_AUTHOR_PERSONALDATA_MARITALSTATUS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('');
INSERT INTO `D_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('married');
INSERT INTO `D_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('unmarried');
INSERT INTO `D_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('divorced');
INSERT INTO `D_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('actually divorced');
INSERT INTO `D_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('widower');
INSERT INTO `D_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('living together');
INSERT INTO `D_3_Author_PERSONALDATA_MARITALSTATUS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`; CREATE TABLE `D_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('');
INSERT INTO `D_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('< 6 years');
INSERT INTO `D_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('between 6-12 years');
INSERT INTO `D_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('> 12 years');
INSERT INTO `D_3_Author_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) VALUES ('unknown');
DROP TABLE IF EXISTS `D_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR`; CREATE TABLE `D_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN` VARCHAR(255) NOT NULL DEFAULT '',  PRIMARY KEY  (`EN`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Self employed');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Unemployed');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Family work');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Public employee');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('Private employee');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('agriculture');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('industry');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('commerce');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('services');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('private');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('leisure');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('other');
INSERT INTO `D_3_Author_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) VALUES ('unknown');
